Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013

##                    LAYER Accident_Index
## 1 20mph existing streets             48
## 2    20mph local streets             72
## 3     20mph main streets            182
## 4                  30mph             98
## 5                  40mph             43
## 6        50, 60 or 70mph              1
## 7        Part time 20mph              1
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20             25
## 2          30            387
## 3          40             35

Mapping accidents with roads: 2014

##                    LAYER Accident_Index
## 1 20mph existing streets            154
## 2    20mph local streets            158
## 3     20mph main streets            389
## 4                  30mph            266
## 5                  40mph             68
## 6        50, 60 or 70mph             14
## 7        Part time 20mph              9
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             39
## 2          30            955
## 3          40             69

Mapping accidents with roads: 2015

##                    LAYER Accident_Index
## 1 20mph existing streets            106
## 2    20mph local streets            156
## 3     20mph main streets            327
## 4                  30mph            254
## 5                  40mph             80
## 6        50, 60 or 70mph             12
## 7        Part time 20mph              6
## 8            Trunk roads              5
##   Speed_limit Accident_Index
## 1          20             34
## 2          30            832
## 3          40             80

Mapping accidents with roads: 2016

##                    LAYER Accident_Index
## 1 20mph existing streets             48
## 2    20mph local streets             57
## 3     20mph main streets             25
## 4                  30mph             28
## 5                  40mph             17
##   Speed_limit Accident_Index
## 1          20              8
## 2          30            148
## 3          40             19

Mapping accidents with roads: 2018

##                    LAYER Accident_Index
## 1 20mph existing streets             64
## 2    20mph local streets             83
## 3     20mph main streets            181
## 4                  30mph            146
## 5                  40mph             47
## 6        50, 60 or 70mph              5
## 7        Part time 20mph              7
## 8            Trunk roads              2
##   Speed_limit Accident_Index
## 1          20            289
## 2          30            191
## 3          40             55

Mapping accidents with roads: 2019

##                    LAYER Accident_Index
## 1 20mph existing streets             31
## 2    20mph local streets             52
## 3     20mph main streets             87
## 4                  30mph             77
## 5                  40mph             24
## 6        50, 60 or 70mph              2
## 7        Part time 20mph              1
## 8            Trunk roads              1
##   Speed_limit Accident_Index
## 1          20            153
## 2          30             97
## 3          40             25

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            356
## 2    20mph local streets            443
## 3     20mph main streets            923
## 4                  30mph            646
## 5                  40mph            208
## 6        50, 60 or 70mph             27
## 7        Part time 20mph             16
## 8            Trunk roads             12
##   Speed_limit Accident_Index
## 1          20            106
## 2          30           2322
## 3          40            203

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets             95
## 2    20mph local streets            135
## 3     20mph main streets            268
## 4                  30mph            223
## 5                  40mph             71
## 6        50, 60 or 70mph              7
## 7        Part time 20mph              8
## 8            Trunk roads              3
##   Speed_limit Accident_Index
## 1          20            442
## 2          30            288
## 3          40             80

Output column: Layer

##     ID Speed_limit              LAYER
## 1 1509          30              30mph
## 2  987          30 20mph main streets
## 3 2505          30              30mph
## 4 1614          30              30mph
## 5 2355          30              30mph
## 6  153          30 20mph main streets

Table: Average annual road traffic collision rates in the city of Edinburgh (GIS)

Table 1: Average annual road traffic collision rates in the city of Edinburgh (GIS)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 30mph 646 223 0.40 0.28 0.12 30.00
Streets at 20mph 356 95 0.22 0.12 0.10 45.45
Streets at 30mph changed to 20mph 1366 403 0.85 0.51 0.34 40.00
Streets at 40mph 208 71 0.13 0.09 0.04 30.77
All streets 1613 792 1.00 1.00 0.00 0.00

Table: Average annual road traffic collision rates in the city of Edinburgh (Stats19)

Table 2: Average annual road traffic collision rates in the city of Edinburgh (Stats19)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 20mph 106 442 0.04 0.55 -0.51 -12.75
Streets at 30mph 2322 288 0.88 0.36 0.52 0.59
Streets at 40mph 203 80 0.08 0.10 -0.02 -0.25
All streets 2631 810 1.00 1.00 0.00 0.00

Effect estimate (GIS)

Effect estimate(GIS)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1054 966 611 810
Effect estimate 31.27

Effect estimate (Stats19)

Effect estimate(Stats19)
Tax year 2013/14 2014/15 2015/16 2018/19
Annual number of collisions 1032 945 599 792
Effect estimate 31.36

Mapping accidents with implementation zones: 2013

##   ImplementationZone Accident_Index
## 1                  1             73
## 2                  2            105
## 3                  3            137
## 4                  4             44
## 5                  5             68
## 6                  6             30
## 7                  7             21

Mapping accidents with implementation zones: 2014

##   ImplementationZone Accident_Index
## 1                  1            168
## 2                  2            275
## 3                  3            298
## 4                  4            109
## 5                  5            132
## 6                  6             89
## 7                  7             58

Mapping accidents with implementation zones: 2015

##   ImplementationZone Accident_Index
## 1                  1            155
## 2                  2            210
## 3                  3            273
## 4                  4             75
## 5                  5            144
## 6                  6             91
## 7                  7             43

Mapping accidents with implementation zones: 2016

##   ImplementationZone Accident_Index
## 1                  1             96
## 2                  2            120
## 3                  3            147
## 4                  4             48
## 5                  5             60
## 6                  6             48
## 7                  7             24

Mapping accidents with implementation zones: 2018

##   ImplementationZone Accident_Index
## 1                  1             88
## 2                  2            125
## 3                  3            160
## 4                  4             53
## 5                  5             68
## 6                  6             46
## 7                  7             30

Mapping accidents with implementation zones: 2019

##   ImplementationZone Accident_Index
## 1                  1             42
## 2                  2             68
## 3                  3             79
## 4                  4             33
## 5                  5             27
## 6                  6             18
## 7                  7             14

Output column: Implementation Zone

##   Accident_Index Speed_limit ImplementationZone
## 1  2013950000001          30                  1
## 2  2013950000002          30                  2
## 3  2013950000003          30                  2
## 4  2013950000007          30                  1
## 5  2013950000010          30                  4
## 6  2013950000058          20                  7

Total accidents per zone

##   ImplementationZone Accident_Index
## 1                  1            622
## 2                  2            903
## 3                  3           1094
## 4                  4            362
## 5                  5            499
## 6                  6            322
## 7                  7            190

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 81

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 60

Control zone 3:South central –> Dundee

## [1] 494

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 286

Control zone 5:West –> Glasgow Kelvin

## [1] 977

Control zone 6:South –> Paisley

## [1] 391

Updated dataset for Edinburgh

##   Accident_Index Speed_limit               LAYER ImplementationZone
## 1        0000419          20  20mph main streets                  2
## 2        0000519          20 20mph local streets                  1
## 3        0000919          40 20mph local streets                  3
## 4        0001019          20               30mph                  2
## 5        0001219          40               40mph                  4
## 6        0001419          30               30mph                  4